How do I use a keyword in a query??
How do I use a keyword in a query??
(OP)
I have a table with no index and there are only keywords. Here is the layout:

So there is a keyword I want the value from I have tried
FREEPBX_SYSTEM_IDENT is the keyword
freepbx_settings is the table
I know this should be easy but I am having a brain fart with this. Any help much appreciated!

So there is a keyword I want the value from I have tried
CODE -->
select * from freepbx_settings like %FREEPBX_SYSTEM_IDENT%
FREEPBX_SYSTEM_IDENT is the keyword
freepbx_settings is the table
I know this should be easy but I am having a brain fart with this. Any help much appreciated!
RE: How do I use a keyword in a query??
CODE
Besides that your code will just error, I don't get why you even consider using LIKE. LIKE is for pattern matching, that would be useful if there are many keywords that have the same keyword pattern, i.e. having the same prefix or suffix.
Chriss
RE: How do I use a keyword in a query??
I only tried Like because it was suggested in some searches I did
CODE -->
gives me the whole row of info. I just need the value in that row
Thanks
RE: How do I use a keyword in a query??
CODE -->
Got me what I wanted.
Thanks for the help Chriss!
RE: How do I use a keyword in a query??
CODE --> sql
RE: How do I use a keyword in a query??
CODE
My guess is that you will get the same record with Spamjim's query and perhaps a few more records with my query. It's still always more straightforward and better to not make LIKE your standard tool to use for any query.
Chriss
RE: How do I use a keyword in a query??