vb.org Archive - Help with Search Query

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Help with Search Query (https://vborg.vbsupport.ru/showthread.php?t=58316)

Kaelon

10-31-2003 02:03 PM

Help with Search Query

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

10-31-2003 02:10 PM

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

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

The % denotes a wildcard search.

Kaelon

10-31-2003 03:44 PM

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:

Quote:

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

I also tried

Quote:

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

11-05-2003 07:57 AM

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.

All times are GMT. The time now is 12:56 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01035 seconds Memory Usage 1,713KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: