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;
Sql query to display [SIZE]
-
- Posts: 115
- Joined: Tue Apr 05, 2005 1:02 pm
Re: Sql query to display [SIZE]
[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
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