SELECT Syntax Question

hi, maybe someone can answer this --- please,

$sql_query = "SELECT * FROM table WHERE some_thingdata =
'$some_partofit'";

can a SELECT statement such as above be crafted, that basically
searches the "some_thingdata" for only part of the stringdata in
there?

That would be cool if someone can show me how that can be done. :-)

Thank you!

Re: SELECT Syntax Question

pokeski@gmail.com wrote:
> hi, maybe someone can answer this --- please,
>
> $sql_query = "SELECT * FROM table WHERE some_thingdata =
> '$some_partofit'";
>
> can a SELECT statement such as above be crafted, that basically
> searches the "some_thingdata" for only part of the stringdata in
> there?
>
> That would be cool if someone can show me how that can be done. :-)
>
> Thank you!
>

$query="SELECT * FROM table WHERE some_thingdata LIKE '%{$some_partofit}%'";

--

//Aho

Re: SELECT Syntax Question

On Aug 24, 11:13 am, "J.O. Aho" wrote:
> poke...@gmail.com wrote:
> > hi, maybe someone can answer this --- please,
>
> > $sql_query = "SELECT * FROM table WHERE some_thingdata =
> > '$some_partofit'";
>
> > can a SELECT statement such as above be crafted, that basically
> > searches the "some_thingdata" for only part of the stringdata in
> > there?
>
> > That would be cool if someone can show me how that can be done. :-)
>
> > Thank you!
>
> $query="SELECT * FROM table WHERE some_thingdata LIKE '%{$some_partofit}%'";
>
> --
>
> //Aho

Wow, very good thank you! :-) Have a great day!~~~~