You will need the RLIKE comparator.
http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html
http://dev.mysql.com/doc/mysql/en/Regexp.html
I haven't tested this but this is pretty close to what you will need
WHERE page_body RLIKE 'img *' and page_body not RLIKE 'img *alt=*'
you will
not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.
-Original Message-
From: Bob Ramsey [mailto:[EMAIL PROTECTED]
Sent: 03 October 2004 12:45
To: [EMAIL PROTECTED]
Chris Blackwell wrote:
not sure you can do this just with mysql, I think your gunna need to select
the html from the db then send it to something like perl or php and use a
regex parser on it.
Yeah, that's what I was afraid of. Now all I have to do is decide
between PERL and PHP for the
You can use regular expression.
Santino
At 6:45 -0500 3-10-2004, Bob Ramsey wrote:
Hi,
I have some web pages in a database and I want to check to make sure
that all of the images have alt tags in them. So what I need to do
is ask something like this in psuedocode:
select page_name from