Help with Search Query

[Kaelon]

Hey, gang,

I'm using phpMyAdmin, and want to manually search through a table for a certain word of phrase. What sort of query would I make, and how would I make it?

Thanks,
Kaelon

[Velocd]

SELECT columns FROM `table` WHERE column LIKE '%phrase%'

Replace columns, table, column, and phrase with your values.

The % denotes a wildcard search.

[Kaelon]

Thanks, Velocd!

I tried this out, but I guess I was confused by the response - I didn't get a list of browsable entries that matched my search. The syntax I used was:

SELECT message FROM `privatemessage` WHERE message LIKE '%phrase%';

I also tried

SELECT * FROM `privatemessage` WHERE message LIKE '%phrase%';

Specifically, I'm trying to look through private messages for mention of a specific illegal activity that investigators has asked me for assistance with. Thanks!

[Issvar]

phpMyAdmin cuts the message field to show it on screen, if you elect to change that specific record you will be able to completely read the text.

You could also write a simple PHP script that shows the full message.