OpenForum RSS: bash mysql select

bash mysql select (richit)

Thu, 04 Oct 2012 05:19:38 GMT

>>>> id=$(mysql -u user -pQWERT -Ne 'SET NAMES UTF8; USE db; SELECT id
>>>> FROM content WHERE pagetitle LIKE "%$name%"')
>>> � �� $name?
>> �� , �� ) $name - �� txt � dos ��
> ��-�� , � �� - ��. �� - ��
> ��, �� , �� _�� . //��
> �� ~~

�� -�� :

"SELECT id FROM site_content WHERE MATCH (pagetitle) AGAINST (+'$name') AND tv_pubhouse LIKE '%$publisher%' AND tv_year='$year'"

bash mysql select (Andrey Mitrofanov)

Wed, 03 Oct 2012 18:08:59 GMT

>>> id=$(mysql -u user -pQWERT -Ne 'SET NAMES UTF8; USE db; SELECT id
>>> FROM content WHERE pagetitle LIKE "%$name%"')
>> � �� $name?
> �� , �� ) $name - �� txt � dos ��

��-�� , � �� - ��. �� - �� , �� , �� _�� . //�� ~~

bash mysql select (richit)

Wed, 03 Oct 2012 15:23:04 GMT

>> id=$(mysql -u user -pQWERT -Ne 'SET NAMES UTF8; USE db; SELECT id
>> FROM content WHERE pagetitle LIKE "%$name%"')
> � �� $name?

�� , �� ) $name - �� txt � dos �� ^M �� )))
��: tr -d "\015"
�� dos2unix �� *.txt ��

bash mysql select (XAnder)

Wed, 03 Oct 2012 13:19:36 GMT

> id=$(mysql -u user -pQWERT -Ne 'SET NAMES UTF8; USE db; SELECT id
> FROM content WHERE pagetitle LIKE "%$name%"')

� �� $name?