search

CollectiveIndustries / StarfleetDelta

Repository for Starfleet Delta Webpage, Database, and all in world scripts
https://www.starfleetdelta.com/
GNU General Public License v3.0
2 stars 4 forks source link

[MySQL] Change the way names are stored #41

Closed MyNameIsKodos closed 7 years ago

MyNameIsKodos commented 7 years ago

I was thinking today that name lookups could be done easily with the computer system that's WIP by doing something like

Computer where is Raven or Computer where is Lieutenant McQuiston

So instead of having a name field, we should break it apart into fname and lname (first, last)

Morketh commented 7 years ago

All of that can be achieved with a simple name LIKE %....% query where the ..... in the example is any search string you want to match the % being a wild-card.

Morketh commented 7 years ago

This could actually build the frame work for the Relational Database. Simple php script could be written to use the query and search for a string

Morketh commented 7 years ago

This is being handled using SID #40