How do I use a keyword in a query??

[EdLentz]

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

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!

 

[Chris Miller]

It's not sufficient to know the data structure to know what you need, but my first guess would be

select * from `freepbx_settings` WHERE `keyword`='FREEPBX_SYSTEM_IDENT'

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

 

[EdLentz]

Thanks Chriss
I only tried Like because it was suggested in some searches I did

select * from `freepbx_settings` WHERE `keyword`='FREEPBX_SYSTEM_IDENT'

gives me the whole row of info. I just need the value in that row

Thanks

 

[EdLentz]

I figured it out

select `value` from `freepbx_settings` WHERE `keyword`='FREEPBX_SYSTEM_IDENT'

Got me what I wanted.

Thanks for the help Chriss!

 

[spamjim]

You can still get a broader search, as you may have initially intended, with the LIKE operator.

select * from `freepbx_settings` WHERE `keyword` LIKE '%FREEPBX_SYSTEM_IDENT%';

 

[Chris Miller]

Of course but a more useful usage of like is when you don't know the full keyword, then you can query this, for example:

select * from `freepbx_settings` WHERE `keyword` LIKE '%PBX%';

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

 

[EdLentz]

Now all I need to do is get this into a variable that I can use. I wish to use it in an email that I have setup. Seems like it should be easy.