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 '' and page_body not RLIKE ''
you will have to experime
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 web_page
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 script
]
Subject: filed that does not contain text between symbols
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 web_pages where page_body does not
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 web_pages where page_body does not contain 'alt='
between '';
But I just can't figure out
