Category : fulltext-index

Here’s my code: $terminosBuscados = ‘Vender la porteria’ $x = $conectarDB->prepare(" SELECT DISTINCT titulo, FROM_UNIXTIME(fecha, ‘%d-%m-%Y’) AS fecha, cuerpo, tipoContenido, autor FROM searchIndex WHERE match(titulo) AGAINST (‘ ? ‘ IN BOOLEAN MODE) ORDER BY contenidoID DESC "); $x->bindParam(1, $terminosBuscados); $x->execute(); $y = $x->fetchAll(PDO::FETCH_ASSOC); This is showing no results at all ($y returns null), when trying ..

Read more