mysql - SQL text search on any record field -
I am creating a grid system and I need to search for any area or string on my record - Even strings, timestamps and numbers
is something like:
from SELECT * where any_FIELD is ('MyText') < / Pre> If not, what would be the way to go for the solution?
PS: I am using my SQL as a database, but I have to support it on Oracle and SQL Server too.
Thanks for the help.
select * match-to-match match (ANY_FIELD_1 , ANY_FIELD_2) You can also see that there are some more operators here that you may need to implement in the code or for example + and < / P> - does not stand
Comments
Post a Comment