giulianoz wrote:
Another way this could be done:
add a filed in the songs table wich contains the numeric representation
of the title/artist/song/whatever and do the seaqrch query on this
field.
i.e.:
db field : "metallica" -> "638255421"
user input "etall" -> "38255"
query: select fields from table where db_field like '%user_input%';
this should solve the regexp missing sql function, but adds some data
to the database and slows the search engine.
How is this different from:
select fields from table where artist_name like '%etall%' ?
R.
--
http://robinbowes.com
If a man speaks in a forest,
and his wife's not there,
is he still wrong?
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
