How do I use a keyword in a query??

• May 25, 2023

• #2

Chris Miller

Programmer

Oct 28, 2020

5,032

DE

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

Code:

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

 

Upvote 0 Downvote

• May 25, 2023

• Thread starter
• #3

EdLentz

Technical User

Mar 20, 2002

85

US

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

Code:

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

 

Upvote 0 Downvote

• May 25, 2023

• Thread starter
• #4

EdLentz

Technical User

Mar 20, 2002

85

US

I figured it out

Code:

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

Got me what I wanted.

Thanks for the help Chriss!

 

Upvote 0 Downvote

• May 26, 2023

• #5

spamjim

Instructor

Mar 17, 2008

1,369

US

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

SQL:

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

 

Upvote 0 Downvote

• May 26, 2023

• #6

Chris Miller

Programmer

Oct 28, 2020

5,032

DE

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:

Code:

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

 

Upvote 0 Downvote

• May 26, 2023

• Thread starter
• #7

EdLentz

Technical User

Mar 20, 2002

85

US

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.

 

Upvote 0 Downvote