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. 

giuliano


-- 
giulianoz
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss

Reply via email to