For example, how many records are available to include such data in the database:
<table class= "Link-more-blue" style= "width:100%;" border= "0" cellspacing= "0" cellpadding= "0" >
<tbody>
<tr class= "Grid-head-wrap" >
<td>file name</td>
<TD width= ">Size</td>"
<TD width= "> </td>"
</tr>
</tbody>
</table>
Query directly using SQL statements:
SELECT Count (*) from driver_lookup_com.content
Where Introtext like '%<table class= "Link-more-blue" style= "width:100%" border= "0" cellspacing= "0" cellpadding = "0" ><tbody>"+
"<tr class=" Grid-head-wrap "><td>file name</td><tdwidth=" ">size</" td><td width= > </td></tr></tbody> </table>% ';
Results no data returned, there is a record in the database, why, may have forgotten the newline character?
SELECT Count (*) from driver_lookup_com.content
where introtext like '%<table class= "Link-more-blue" style= "width:100%" border= "0" cellspacing= "0" C ellpadding= "0" >\ r \ n<tbody> "+
"\ r \ n<tr class=" grid-head-wrap ">\ r \<td>file name</td>\ r \ n<t D width= ">Size</td>\ r \ n<td width=" > </td>\r\n</tr>\ r \ n </tbody></table>% ';
Line break: windows with \ r \ n
Linux with \ n
MySQL Query Long data is no value returned (can try line break)