doutu7123 2014-02-15 07:44
浏览 13

变量返回全文搜索的所有结果?

This is my first time using the full text search feature in MySQL.

I am using PDO statements and a select * statement.

SELECT *   
FROM `table` 
WHERE MATCH (var1) AGAINST (:field1 IN BOOLEAN MODE)
  AND MATCH (var2) AGAINST (:field2 IN BOOLEAN MODE)

If var1 or var2 are undefined, what variable can I set them to so that all results from field1 or field2 are displayed? Currently I get no results.

Before using Full Text search I would use

if (!isset($var1)) {
    $var1 = '%' . '' . '%';
}

with a LIKE statement that would return all results when a user has not specified any selection, etc.

I have tried using * but this doesn't work either.

Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 ogg dd trandata 报错
    • ¥15 高缺失率数据如何选择填充方式
    • ¥50 potsgresql15备份问题
    • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
    • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
    • ¥60 pb数据库修改与连接
    • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
    • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
    • ¥20 神经网络Sequential name=sequential, built=False
    • ¥16 Qphython 用xlrd读取excel报错