SmokyHosts Support Forums - Webhosting and Webdesigning Support!

I'd like to run a query that would search the post table for [SIZE] bbcode.

This works to list all posts with my name in it. How would I modify it to search for [SIZE].

SELECT *
FROM post
WHERE pagetext
LIKE '%Andy%'
ORDER BY threadid DESC;

[quote="pryj"]I'd like to run a query that would search the post table for [SIZE] bbcode.

This works to list all posts with my name in it. How would I modify it to search for [SIZE].

SELECT *
FROM post
WHERE pagetext
LIKE '%Andy%'
ORDER BY threadid DESC]

SELECT *
FROM post
WHERE [SIZE]
LIKE '%Andy%'
ORDER BY threadid DESC;


try that